<?php


//配置skus.php文件sql生成
$sql = "SELECT t_sku.channel_id,t_in.sku_sn,t_sku.channel_goods_sn, t_in.goods_sn, t_in.actual_number, t_in.available_number, g.shop_price as product_price, g.goods_name, g.outer_goods_sn FROM t_channel_sku AS t_sku LEFT JOIN t_sku_inventory AS t_in ON t_sku.sku_sn = t_in.sku_sn LEFT JOIN product_goods AS g ON t_in.goods_sn = g.goods_sn WHERE t_in.sku_sn IN ( '0593829002003', '0593829002002', '0593829002004', '0593829001003', '0593829027003', '0593829001002', '0476315024003', '0617878003002', '0593829001004', '0593829006003') and t_sku.channel_id = 1";


//库存修改
$sql1 = "update `t_sku_inventory` set actual_number= 10000000 , available_number = 10000000 where sku_sn in('0593829002003','0593829002002','0593829002004','0593829001003','0593829027003','0593829001002','0476315024003','0617878003002','0593829001004','0593829006003');";

$sql2 = "update `t_channel_sku_inventory` set actual_number= 10000000 , available_number = 10000000 where sku_sn in('0593829002003','0593829002002','0593829002004','0593829001003','0593829027003','0593829001002','0476315024003','0617878003002','0593829001004','0593829006003');";


$sql3 = "update `t_notice_sku_inventory` set stock= 10000000 where sku_sn in('0593829002003','0593829002002','0593829002004','0593829001003','0593829027003','0593829001002','0476315024003','0617878003002','0593829001004','0593829006003');";

$sql4 = "update `wms_inventory` set qty= 10000000 where sku_sn in('0593829002003','0593829002002','0593829002004','0593829001003','0593829027003','0593829001002','0476315024003','0617878003002','0593829001004','0593829006003');";
